'EViews Programming Code for Philippines

wfopen  "C:\Users\Maryam\Desktop\BS Studies\PhD Thesis-II\EViews and STATA Progarm Codes\Chapter-6\Philippines.wf1"

'****************************************************************************
'Group Plot for RER_CPI, RER_DEF, RER_DEF_NT and A_TILDE
'****************************************************************************
group gA rer_cpi rer_def rer_def_nt A_tilde
freeze(group_plot) gA.line(x)
group_plot.setelem(1) lcolor(black) symbol(7) lpat(1)
group_plot.setelem(2) lcolor(black) symbol(4) lpat(1)
group_plot.setelem(3) lcolor(black) symbol(1) lpat(1)
group_plot.setelem(3) lcolor(black)
group_plot.options linepat
group_plot.addtext(t) Real ERs and Productivity Gap (Philippines & U.S): 1971-2013
group_plot.addtext(b) Year
group_plot.addtext(l) RER_CPI
group_plot.addtext(l) RER_DEF
group_plot.addtext(l) RER_CPI, RER_DEF & RER_DEF_NT
group_plot.addtext(r) A_TILDE
'************************************************************
'************************************************************
create y 1971 2013
'importing data from Excel for Philippines
import  "C:\Users\Maryam\Desktop\BS Studies\PhD Thesis-II\EViews and STATA Progarm Codes\Chapter-6\Chapter 6.xlsx" range="Philippines"
'***************************************************************************************************
'CASE-1: ESTIMATING BALASSA-SAMUELSON EFFECT FOR RER_CPI & A_TILDE
'***************************************************************************************************
'*************************************************************
'STEP 0: Tests for Unit Root in Individual Time Series
'*************************************************************
'*********************************
'Graph for Philippines's RER_CPI
'*********************************
                                        
genr rer_cpi = rer_cpi
freeze(figure_rer_cpi) rer_cpi.line
figure_rer_cpi.addtext(t) rer_cpi (Philippines):  1971-2013
figure_rer_cpi.addtext(b) Year
figure_rer_cpi.addtext(l) rer_cpi
figure_rer_cpi.legend(off)
                                                 
'We see from the FIGURE that rer_cpi has time trend to it.  So we would include both an intercept and a time trend in our unit root regression equations. 

'************************************************
'ADF Unit Root Test for Philippines's RER_CPI
'************************************************
 
freeze(table_6_6_rer_cpi_adf) rer_cpi.uroot(adf,trend,info=sic)

'Note that the SIC automatic lag selection picks lags, p = 2.  The unit root test produces a t-value of -5.21 which is greater than our 5% criterion -3.55.  Thus, at this point, we cannot reject the null of a unit root.

'Now, let's check for white noise.  To do that, I first set all the residuals = 0, then run the ADF test and finally will check for white noise.

genr resid = 0
freeze(mode=overwrite,rer_cpi_adf) rer_cpi.uroot(adf,const,trend,info=sic)
freeze(rer_cpi_adf_correl) resid.correl
 
'Based on the Q-statistic, I conclude that the residuals are white noise.  Putting it all together, I conclude that the rer_cpi series is level stationary.

'*****************************************************
'DF-GLS Unit Root Test for Philippines's RER_CPI
'*****************************************************
 
freeze(table_6_6_rer_cpi_dfgls) rer_cpi.uroot(dfgls,trend,info=sic)

'Note that the SIC automatic lag selection picks lags, p = 0.  The unit root test produces a t-value of -1.72 which is greater than our 5% criterion -3.19.  Thus, at this point, we may not reject the null of unit root.

'Now let's see if the series is difference stationary or not

genr rer_cpidiff = d(rer_cpi)
freeze(table_6_6_rer_cpidiff1_dfgls_d) rer_cpidiff.uroot(dfgls,const,info=sic)

'Note that the SIC automatic lag selection picks no lags, p = 0.  The unit root test produces a t-value of -5.54 which is now smaller than our 5% criterion -1.95. Thus, we may reject the null of non-stationarity in first differenced series of rer_cpi.  

''Putting it all together, I conclude that the rer_cpi series is I(1), a finding incompatible with my ADF test results.

'*************************************************
'Graph for Philippines's Productivity (a_tilde)
'*************************************************
                                        
genr a_tilde = a_tilde
freeze(figurea_tilde) a_tilde.line
figurea_tilde.addtext(t) a_tilde (Philippines):  1971-2013
figurea_tilde.addtext(b) Year
figurea_tilde.addtext(l) a_tilde
figurea_tilde.legend(off)
                                                 
'We see from the FIGURE that a_tilde has time trend to it.  So we would include both an intercept and a time trend in our unit root regression equations. 

'*******************************************************
'ADF Unit Root Test for Philippines's Productivity
'*******************************************************
 
freeze(table_6_6_a_tilde_adf) a_tilde.uroot(adf,trend,info=sic)

'Note that the SIC automatic lag selection picks lags, p =0.  The unit root test produces a t-value of -2.35 which is greater than our 5% criterion -3.52.  Thus, at this point, we can reject the null of a unit root.

'Now, let's check for white noise.  To do that, I first set all the residuals = 0, then run the ADF test and finally will check for white noise.

genr resid = 0
freeze(mode=overwrite,a_tilde_adf) a_tilde.uroot(adf,const,trend,info=sic)
freeze(a_tilde_adf_correl) resid.correl
 
'Based on the Q-statistic, I conclude that the residuals are white noise.  Putting it all together, I conclude that the a_tilde series is not level stationary.

'The next thing I do is test whether the differenced series is stationary using the ADF test.  I once again begin by graphing the (differenced) series.
 
genr a_tildediff = d(a_tilde)
freeze(figure_a_tildediff) a_tildediff.line
figure_a_tildediff.addtext(t) da_tilde (Philippines):  1971-2013
figure_a_tildediff.addtext(b) Year
figure_a_tildediff.addtext(l) Da_tilde
figure_a_tildediff.legend(off)

'From the graph, the series clearly does not have a time trend to it. So, I would test the series for unit with an intercept only.

'So we begin the whole process over again: 

genr a_tildediff = d(a_tilde)
freeze(table_6_6_a_tildediff1_adf) a_tildediff.uroot(adf,const,info=sic)

'Note that the SIC automatic lag selection picks no lags, p =1.  The unit root test produces a t-value of -7.11 which is now smaller than our 5% criterion -2.94.  Thus, we may now reject the null of non-stationarity in first differenced series of a_tilde.  There is no reason to go further.  The last thing we do is to check ADF regression result for white noise.

genr resid = 0
freeze(mode=overwrite,a_tildediff1_adf) a_tildediff.uroot(adf,const,info=sic)
freeze(a_tildediff1_adf_correl) resid.correl

''Based on the Q-statistic, I conclude that the residuals are white noise.  Putting it all together, I conclude that the a_tilde series is I(1).

'************************************************************
'DF-GLS Unit Root Test for Philippines's Productivity
'************************************************************
 
freeze(table_6_6_a_tilde_dfgls) a_tilde.uroot(dfgls,trend,info=sic)

'Note that the SIC automatic lag selection picks lags, p = 0.  The unit root test produces a t-value of -2.45 which is greater than our 5% criterion -3.19.  Thus, at this point, we may not reject the null of a unit root.
 
'Now let's see if the series is difference stationary or not

genr a_tildediff = d(a_tilde)
freeze(table_6_6_a_tilde1diff1_dfgls) a_tildediff.uroot(dfgls,const,info=sic)

'Note that the SIC automatic lag selection picks no lags, p = 3.  The unit root test produces a t-value of -1.53 which is still greater than our 5% criterion -1.95. Thus, we may not reject the null of non-stationarity in first differenced series of a_tilde.  

''Putting it all together, I conclude that the a_tilde series is greater than I(1), a finding incompatible with my ADF test results.

'*********************************************
'Single Equation Cointegration Methods
'*********************************************

'**********************************************************
''Graph the suspected cointegrated series together
'**********************************************************

'The first step is to plot a graph of the suspected series.  This is very important!

group g1 rer_cpi a_tilde
freeze(figure6_6a) g1.line(x)
figure6_6a.setelem(1) lcolor(black) 
figure6_6a.setelem(2) lcolor(black) lpat(8)
figure6_6a.options linepat
figure6_6a.addtext(t) rer_cpi and a_tilde (Philippines & U.S): 1971-2013
figure6_6a.addtext(b) Year
figure6_6a.addtext(l) rer_cpi
figure6_6a.addtext(r) a_tilde

''*******************************************************
''S1.A.Engle-Granger Approach to Cointegration
'*******************************************************
 
freeze(table_6_6_egc_rer_cpi) g1.coint(method=eg)

'The null hypothesis will be rejected as suggested by sample statistics.

''******************************************
''S1.B.Error Correction Model (ECM)
'*******************************************
''**********************************************
'Selecting the number of lags in the VAR
'***********************************************

'NOTE: We do this because we need to have the "right" number of lags when it comes time to estimate our VEC model and test for cointegration.

var table_6_6_var1.ls 1 4   g1
freeze(table_6_6_var1_lagtest1) table_6_6_var1.laglen(4)
freeze(table_6_6_var1_lagtest2) table_6_6_var1.testlags

'The laglength test above indicates that the VAR has 1 lag but the residuals are not white at this number of lag. So, I had to raise the number of lags from 1 to 4 and thus obtained white residuals.  

var table_6_6_var2.ls 1 4  g1
freeze(table_6_6_var2_artest1) table_6_6_var2.correl
freeze(table_6_6_var2_artest2) table_6_6_var2.qstats(12)
freeze(table_6_6_var2_artest3) table_6_6_var2.arlm(12)

'The residuals are still not white noise but I can't go beyond this number of lags.

'We now try different lags of d(a_tilde), comparing SIC values across specifications.

genr resid = 0
equation eg.ls rer_cpi c a_tilde
genr ec1 = resid

var table_6_6_eg2a_cpi.ls 0 0 d(rer_cpi)   @  c ec1(-1) d(rer_cpi(-1)) d(rer_cpi(-2)) d(rer_cpi(-3)) d(rer_cpi(-4)) 

var table_6_6_eg2b_cpi.ls 0 0 d(rer_cpi)   @  c ec1(-1) d(rer_cpi(-1)) d(rer_cpi(-2)) d(rer_cpi(-3)) d(rer_cpi(-4)) d(a_tilde(-1))

var table_6_6_eg2c_cpi.ls 0 0 d(rer_cpi)   @  c ec1(-1) d(rer_cpi(-1)) d(rer_cpi(-2)) d(rer_cpi(-3)) d(rer_cpi(-4)) d(a_tilde(-1)) d(a_tilde(-2))

'The evidence suggests that Model A is best.  Now we test that model for serial correlation.

var table_6_6_eg2a_cpi.ls 0 0 d(rer_cpi)   @   c ec1(-1) d(rer_cpi(-1)) d(rer_cpi(-2)) d(rer_cpi(-3)) d(rer_cpi(-4))
freeze(table_6_6_eg2a1_cpi_artest1) table_6_6_eg2a_cpi.correl
freeze(table_6_6_eg2a2_cpi_artest2) table_6_6_eg2a_cpi.qstats(12)
freeze(table_6_6_eg2a3_cpi_artest3) table_6_6_eg2a_cpi.arlm(12)

'The residuals are absolutely white noise.

''*************************
''Estimating EC Model  
'**************************

'We'll now take the above specified model and turn it into an ECM. We shall run NW-HAC least squares model for establishing error correction mechanism.

'We now estimate the corresponding ECM:

equation table_6_6_ecm_rer_cpi.ls(n) d(rer_cpi) c ec1(-1) d(rer_cpi(-1)) d(rer_cpi(-2)) d(rer_cpi(-3)) d(rer_cpi(-4)) 

'Note that the SR effect is significant as the error correction coefficient -0.30 is statistically significant at better than 1% significance level.

''**********************************************
''S2.A & S2.B: Obtaining LR Coefficients
'***********************************************
'Now, by employing FMOLS and DOLS cointegration regression estimators, finally we shall calculate our LR coefficient i.e. BS coefficient for Philippines against U.S.

equation table_6_6_LReqn1a_fmols.cointreg(method=fmols) rer_cpi a_tilde

equation table_6_6_LReqn1b_dols.cointreg(method=dols, trend=constant, lag=2,lead=2 ) rer_cpi a_tilde

'The BS coefficient obtained through FMOLS and DOLS estimators are 0.06 and 0.20 respectively but are statistically insignificant. Thus, there is NO valid evidence in support of BS effect existing for Philippines.

''******************************************
'Multivariate Cointegration Approach
'******************************************

''********************************************************
''Check if the VAR (2) model is dynamically stable
'*********************************************************
freeze(table_6_6_var2_varstable) table_6_6_var2.arroots(graph)

'The model is dynamically stable.

''**********************************************************************
''M1.A & M1.B: Identifying the number of cointegrating vectors
'***********************************************************************

'Having identified the appropriate number of lags to put in, I now go on to test for the appropriate number of cointegrating equations.

freeze(table_6_6_var2_coint1) table_6_6_var2.coint(s,4)

'This command estimates all possible combinations of constants and trends in the level data series and the cointegrating equations. All the results indicate 0 cointegrating vectors.
'
'GENERAL NOTE:, in practice, cases 1 and 5 are rarely used. One should use case 1 only if one knows that all series have zero mean. Case 5 may provide a good fit in-sample but will produce implausible forecasts out-of-sample. As a rough guide, use case 2 if none of the series appear to have a trend. For trending series, use case 3 if you believe all trends are stochastic; if you believe some of the series are trend stationary, use case 4.

'Note that the 5 cases are identified under "Johansen cointegration test" in EViews. They run from most restrictive (no constants in either the level series or CEs) to most general (trend terms in both the level series and CEs).

''******************************************************************
''M2.A, M2.B & M3: Vector Error Correction Model (VECM)
'*******************************************************************

' For estimating the LR relationship, corresponding VEC command is:

var table_6_6_vec1c.ec(c,1) 1 3 rer_cpi a_tilde

'CONCLUSION:  I conclude that rer_cpi and a_tilde are not cointegrated in the Philippines data.

'***************************************************************************************************
'CASE-2: ESTIMATING BALASSA-SAMUELSON EFFECT FOR RER_DEF & A_TILDE
'***************************************************************************************************
'*************************************************************
'STEP 0: Tests for Unit Root in Individual Time Series
'*************************************************************
'*********************************
'Graph for Philippines's RER_DEF
'*********************************
                                        
genr rer_def = rer_def
freeze(figure_rer_def) rer_def.line
figure_rer_def.addtext(t) rer_def (Philippines):  1971-2013
figure_rer_def.addtext(b) Year
figure_rer_def.addtext(l) rer_def
figure_rer_def.legend(off)
                                                 
'We see from the FIGURE that rer_def has time trend to it.  So we would include both an intercept and a time trend in our unit root regression equations.  
'*****************************************************
'ADF Unit Root Test for Philippines's RER_DEF
'*****************************************************
 
freeze(table_6_6_rer_def_adf) rer_def.uroot(adf,trend,lag=1)

'Note that I specify lag selection as p = 1 we obtaining white residuals. The unit root test produces a t-value of -1.44 which is greater than our 5% criterion -3.52.  Thus, at this point, we cannot reject the null of a unit root.

'Now, let's check for white noise.  To do that, I first set all the residuals = 0, then run the ADF test and finally will check for white noise.

genr resid = 0
freeze(mode=overwrite,rer_def_adf) rer_def.uroot(adf,const,trend,lag=1)
freeze(rer_def_adf_correl) resid.correl
 
'Based on the Q-statistic, I conclude that the residuals are white noise. Putting it all together, I conclude that the rer_def series is not level stationary.

'The next thing I do is test whether the differenced series is stationary using the ADF test. I once again begin by graphing the (differenced) series.
 
genr rer_defdiff = d(rer_def)
freeze(figure_rer_defdiff) rer_defdiff.line
figure_rer_defdiff.addtext(t) drer_def (Philippines):  1971-2013
figure_rer_defdiff.addtext(b) Year
figure_rer_defdiff.addtext(l) drer_def
figure_rer_defdiff.legend(off)

'From the graph, the series clearly does not have a time trend to it. So, I would test the series for unit with an intercept only.

'So we begin the whole process over again: 

genr rer_defdiff = d(rer_def)
freeze(table_6_6_rer_defdiff1_adf) rer_defdiff.uroot(adf,const,info=sic)

'Note that the SIC automatic lag selection picks no lags, p =0. The unit root test produces a t-value of -4.57 which is now smaller than our 5% criterion -2.93.  Thus, we may now reject the null of non-stationarity in first differenced series of rer_def.  There is no reason to go further.  The last thing we do is to check ADF regression result for white noise.

genr resid = 0
freeze(mode=overwrite,rer_defdiff1_adf) rer_defdiff.uroot(adf,const,info=sic)
freeze(rer_defdiff1_adf_correl) resid.correl

''Based on the Q-statistic, I conclude that the residuals are white noise.  Putting it all together, I conclude that the rer_def series is I(1).

'*****************************************************
'DF-GLS Unit Root Test for Philippines's RER_DEF
'*****************************************************
 
freeze(table_6_6_rer_def_dfgls) rer_def.uroot(dfgls,trend,lag=1)

'Note that I specifuy lag p = 1 to obtain white residuals.  The unit root test produces a t-value of -1.71 which is greater than our 5% criterion -3.19.  Thus, at this point, we may not reject the null of unit root.

'Now let's see if the series is difference stationary or not

genr rer_cpidiff = d(rer_def)
freeze(table_6_6_rer_defdiff1_dfgls_d) rer_defdiff.uroot(dfgls,const,info=sic)

'Note that the SIC automatic lag selection picks no lags, p = 0.  The unit root test produces a t-value of -4.62 which is now smaller than our 5% criterion -1.95. Thus, we may reject the null of non-stationarity in first differenced series of rer_def.  

''Putting it all together, I conclude that the rer_def series is I(1), a finding compatible with my ADF test results.

'*********************************************
'Single Equation Cointegration Methods
'*********************************************
'**********************************************************
''Graph the suspected cointegrated series together
'**********************************************************

'The first step is to plot a graph of the suspected series.  This is very important!

group g2 rer_def a_tilde
freeze(figure6_6b) g2.line(x)
figure6_6b.setelem(1) lcolor(black) 
figure6_6b.setelem(2) lcolor(black) lpat(8)
figure6_6b.options linepat
figure6_6b.addtext(t) rer_def and a_tilde (Philippines & U.S): 1971-2013
figure6_6b.addtext(b) Year
figure6_6b.addtext(l) rer_def
figure6_6b.addtext(r) a_tilde

''*******************************************************
''S1.A.Engle-Granger Approach to Cointegration
'*******************************************************

freeze(table_6_6_egc_rer_def) g2.coint(method=eg)

'The null hypothesis will not be rejected as suggested by sample statistics.

''******************************************
''S1.B.Error Correction Model (ECM)
'*******************************************

''**********************************************
'Selecting the number of lags in the VAR
'***********************************************

'NOTE: We do this because we need to have the "right" number of lags when it comes time to estimate our VEC model and test for cointegration.

var table_6_6_var3.ls 1 4   g2
freeze(table_6_6_var3_lagtest1) table_6_6_var3.laglen(4)
freeze(tale_6_6_var3_lagtest2) table_6_6_var3.testlags


'The lag length test above indicates that the VAR has 1 lag. But the resuduals are not white noise. So I had to raise the number of lags from 1 to 4 to get white residuals.

var table_6_6_var4.ls 1 4  g2
freeze(table_6_6_var4_artest1) table_6_6_var4.correl
freeze(table_6_6_var4_artest2) table_6_6_var4.qstats(12)
freeze(table_6_6_var4_artest3) table_6_6_var4.arlm(12)

'We now try different lags of d(a_tilde), comparing SIC values across specifications.

genr resid = 0
equation eg.ls rer_def c a_tilde
genr ec2 = resid

var table_6_6_eg2a_def.ls 0 0 d(rer_def)   @  c ec2(-1) d(rer_def(-1)) d(rer_def(-2)) d(rer_def(-3)) d(rer_def(-4)) 

var table_6_6_eg2b_def.ls 0 0 d(rer_def)   @  c ec2(-1) d(rer_def(-1)) d(rer_def(-2)) d(rer_def(-3)) d(rer_def(-4))  d(a_tilde(-1))

var table_6_6_eg2c_def.ls 0 0 d(rer_def)   @  c ec2(-1) d(rer_def(-1)) d(rer_def(-2)) d(rer_def(-3)) d(rer_def(-4)) d(a_tilde(-1)) d(a_tilde(-2))

'The evidence suggests that Model A is best.  Now we test that model for serial correlation.

var table_6_6_eg2a_def.ls 0 0 d(rer_def)   @   c ec2(-1) d(rer_def(-1)) d(rer_def(-2)) d(rer_def(-3)) d(rer_def(-4)) 
freeze(table_6_6_eg2a1_def_artest1) table_6_6_eg2a_def.correl
freeze(table_6_6_eg2a2_def_artest2) table_6_6_eg2a_def.qstats(12)
freeze(table_6_6_eg2a3_def_artest3) table_6_6_eg2a_def.arlm(12)

'The residuals are absolutely white noise.

''*************************
'Estimating EC Model  
'**************************

'We'll now take the above specified model and turn it into an ECM. We shall run NW-HAC least squares model for establishing error correction mechanism.

'We now estimate the corresponding ECM:

equation table_6_6_ecm_rer_def.ls(n) d(rer_def) c ec2(-1) d(rer_def(-1)) d(rer_def(-2)) d(rer_def(-3)) d(rer_def(-4)) 

'Note that the SR effect is insignificant as the error correction coefficient -0.06 and is statistically insignificant even at 10% significance level.

''******************************************
'Multivariate Cointegration Approach
'******************************************

''*********************************************************
''Check if the VAR (4) model is dynamically stable
'*********************************************************
freeze(var4_varstable) table_6_6_var4.arroots(graph)

'The model is dynamically stable.

''**********************************************************************
''M1.A & M1.B: Identifying the number of cointegrating vectors
'***********************************************************************

'Having identified the appropriate number of lags to put in, I now go on to test for the appropriate number of cointegrating equations.

freeze(table_6_6_var4_coint2) table_6_6_var4.coint(s,4)

'This command estimates all possible combinations of constants and trends in the level data series and the cointegrating equations. Trace statistic of Case 3 indicate 1 cointegrating vector.
'
'GENERAL NOTE:, in practice, cases 1 and 5 are rarely used. One should use case 1 only if one knows that all series have zero mean. Case 5 may provide a good fit in-sample but will produce implausible forecasts out-of-sample. As a rough guide, use case 2 if none of the series appear to have a trend. For trending series, use case 3 if you believe all trends are stochastic; if you believe some of the series are trend stationary, use case 4.

'Note that the 5 cases are identified under "Johansen cointegration test" in EViews. They run from most restrictive (no constants in either the level series or CEs) to most general (trend terms in both the level series and CEs).

''******************************************************************
''M2.A, M2.B & M3: Vector Error Correction Model (VECM)
'*******************************************************************

' For estimating the LR relationship, corresponding VEC command is:

var table_6_6_vec2c.ec(c,1) 1 3 rer_def a_tilde

'CONCLUSION:  I conclude that rer_def and a_tilde are not cointegrated in the Philippines data.

'********************************************************************************************************
'CASE-3: ESTIMATING BALASSA-SAMUELSON EFFECT FOR RER_DEF_NT & A_TILDE
'********************************************************************************************************
'*************************************************************
'STEP 0: Tests for Unit Root in Individual Time Series
'*************************************************************
'******************************************
'Graph for Philippines's RER_DEF_NT
'******************************************
                                        
genr rer_def_nt = rer_def_nt
freeze(figure_rer_def_nt) rer_def_nt.line
figure_rer_def_nt.addtext(t) rer_def_nt (Philippines):  1971-2013
figure_rer_def_nt.addtext(b) Year
figure_rer_def_nt.addtext(l) rer_def_nt
figure_rer_def_nt.legend(off)
                                                 
'We see from the FIGURE that rer_def_nt has time trend to it.  So we would include both an intercept and a time trend in our unit root regression equations. 

'********************************************************
'ADF Unit Root Test for Philippines's RER_DEF_NT
'********************************************************
 
freeze(table_6_6_rer_def_nt_adf) rer_def_nt.uroot(adf,trend,info=sic)

'Note that the SIC automatic lag selection picks lags, p = 0. The unit root test produces a t-value of -1.69 which is greater than our 5% criterion -3.52.  Thus, at this point, we cannot reject the null of a unit root.

'Now, let's check for white noise. To do that, I first set all the residuals = 0, then run the ADF test and finally will check for white noise.

genr resid = 0
freeze(mode=overwrite,rer_def_nt_adf) rer_def_nt.uroot(adf,const,trend,info=sic)
freeze(rer_def_nt_adf_correl) resid.correl
 
'Based on the Q-statistic, I conclude that the residuals are white noise.  Putting it all together, I conclude that the rer_def_nt series is not level stationary.

'The next thing I do is test whether the differenced series is stationary using the ADF test.  I once again begin by graphing the (differenced) series.
 
genr rer_def_ntdiff = d(rer_def_nt)
freeze(figure_rer_def_ntdiff) rer_def_ntdiff.line
figure_rer_def_ntdiff.addtext(t) drer_def_nt (Philippines):  1971-2013
figure_rer_def_ntdiff.addtext(b) Year
figure_rer_def_ntdiff.addtext(l) drer_def_nt
figure_rer_def_ntdiff.legend(off)

'From the graph, the series clearly does not have a time trend to it. So, I would test the series for unit with an intercept only.

'So we begin the whole process over again: 

genr rer_def_ntdiff = d(rer_def_nt)
freeze(table_6_6_rer_def_ntdiff1_adf) rer_def_ntdiff.uroot(adf,const,lag=2)

'Note that I specify lag p =1 to obtain white residuals.  The unit root test produces a t-value of -2.76 which is still greater than our 5% criterion -2.94.  Thus, we may not reject the null of non-stationarity in first differenced series of rer_def_nt.  There is no reason to go further.  The last thing we do is to check ADF regression result for white noise.

genr resid = 0
freeze(mode=overwrite,rer_def_ntdiff1_adf) rer_def_ntdiff.uroot(adf,const,lag=2)
freeze(rer_def_ntdiff1_adf_correl) resid.correl

''Based on the Q-statistic, I conclude that the residuals are white noise. Putting it all together, I conclude that the rer_def_nt series is greater than I(1).

'**************************************************************
'DF-GLS Unit Root Test for Philippines's RER_DEF_NT
'**************************************************************
 
freeze(table_6_6_rer_def_nt_dfgls) rer_def_nt.uroot(dfgls,trend,info=sic)

'Note that the SIC automatic lag selection picks lags, p = 0. The unit root test produces a t-value of -1.75 which is greater than our 5% criterion -3.19. Thus, at this point, we may not reject the null of a unit root. 

'Now let's see if the series is difference stationary or not

Genr rer_def_ntdiff = d(rer_def_nt)
freeze(table_6_6_rer_def_nt1diff1_dfgls) rer_def_ntdiff.uroot(dfgls,const,lag=2)

'Note that the SIC automatic lag selection picks no lags, p = 0.  The unit root test produces a t-value of -2.76 which is still greater than our 5% criterion -1.94. Thus, we may not reject the null of non-stationarity in first differenced series of rer_def_nt.  

''Putting it all together, I conclude that the rer_def_nt series is greater than I(1), a finding compatible with my ADF test results.

'*********************************************
'Single Equation Cointegration Methods
'*********************************************

'**********************************************************
''Graph the suspected cointegrated series together
'**********************************************************

'The first step is to plot a graph of the suspected series.  This is very important!

group g3 rer_def_nt a_tilde
freeze(figure6_6) g3.line(x)
figure6_6.setelem(1) lcolor(black) 
figure6_6.setelem(2) lcolor(black) lpat(8)
figure6_6.options linepat
figure6_6.addtext(t) rer_def_nt and a_tilde (Philippines & U.S): 1971-2013
figure6_6.addtext(b) Year
figure6_6.addtext(l) rer_def_nt
figure6_6.addtext(r) a_tilde

''*******************************************************
''S1.A.Engle-Granger Approach to Cointegration
'*******************************************************
 
freeze(table_6_6_egc_rer_def_nt) g3.coint(method=eg)

'The null hypothesis will be rejected as suggested by sample statistics. 

''******************************************
''S1.B.Error Correction Model (ECM)
'*******************************************
''**********************************************
'Selecting the number of lags in the VAR
'***********************************************

'NOTE: We do this because we need to have the "right" number of lags when it comes time to estimate our VEC model and test for cointegration.

var table_6_6_var5.ls 1 6   g3
freeze(table_6_6_var5_lagtest1) table_6_6_var5.laglen(4)
freeze(tale_6_6_var5_lagtest2) table_6_6_var5.testlags

'The lag length test above indicates that the VAR has 1 lags. But the residuals were not white noise at this number of lags. So I raised the number of lags from 1 to 3 and thus obatined white residuals. 

var table_6_6_var6.ls 1 3  g3
freeze(table_6_6_var6_artest1) table_6_6_var6.correl
freeze(table_6_6_var6_artest2) table_6_6_var6.qstats(12)
freeze(table_6_6_var6_artest3) table_6_6_var6.arlm(12)

'We now try different lags of d(a_tilde), comparing SIC values across specifications.

genr resid = 0
equation eg.ls rer_def_nt c a_tilde
genr ec3 = resid

var table_6_6_eg2a_def_nt.ls 0 0 d(rer_def_nt)   @  c ec3(-1) d(rer_def_nt(-1)) d(rer_def_nt(-2)) d(rer_def_nt(-3))

var table_6_6_eg2b_def_nt.ls 0 0 d(rer_def_nt)   @  c ec3(-1) d(rer_def_nt(-1)) d(rer_def_nt(-2)) d(rer_def_nt(-3)) d(a_tilde(-1))

var table_6_6_eg2c_def_nt.ls 0 0 d(rer_def_nt)   @  c ec3(-1) d(rer_def_nt(-1)) d(rer_def_nt(-2)) d(rer_def_nt(-3)) d(a_tilde(-1)) d(a_tilde(-2))

'The evidence suggests that Model A is best.  Now we test that model for serial correlation.

var table_6_6_eg2a_def_nt.ls 0 0 d(rer_def_nt)   @   c ec3(-1) d(rer_def_nt(-1)) d(rer_def_nt(-2)) d(rer_def_nt(-3))
freeze(table_6_6_eg2a1_def_nt_artest1) table_6_6_eg2a_def_nt.correl
freeze(table_6_6_eg2a2_def_nt_artest2) table_6_6_eg2a_def_nt.qstats(12)
freeze(table_6_6_eg2a3_def_nt_artest3) table_6_6_eg2a_def_nt.arlm(12)

'The residuals are absolutely white noise. 

''*************************
'Estimating EC Model  
'**************************

'We'll now take the above specified model and turn it into an ECM. We shall run NW-HAC least squares model for establishing error correction mechanism.

'We now estimate the corresponding ECM:

equation table_6_6_ecm_rer_def_nt.ls(n) d(rer_def_nt) c ec3(-1) d(rer_def_nt(-1)) d(rer_def_nt(-2)) d(rer_def_nt(-3))

'Note that the SR effect is significant as the error correction coefficient -0.31 is statistically significant at better than 1% significance level.

''**********************************************
''S2.A & S2.B: Obtaining LR Coefficients
'***********************************************

'Now, by employing FMOLS and DOLS cointegration regression estimators, finally we shall calculate our LR coefficient i.e. BS coefficient for Philippines against U.S.

equation table_6_6_LReqn3a_fmols.cointreg(method=fmols) rer_def_nt a_tilde

equation table_6_6_LReqn3b_dols.cointreg(method=dols, trend=constant, lag=2,lead=2 ) rer_def_nt a_tilde

'The BS coefficients obtained through FMOLS and DOLS estimators are -0.01 and-0.10. The two coefficients and/or statistically insignificant. Thus, there is insufficient evidence in support of BS effect existing for Philippines.

''******************************************
'Multivariate Cointegration Approach
'******************************************

''********************************************************
''Check if the VAR (6) model is dynamically stable
'*********************************************************
freeze(var6_varstable) table_6_6_var6.arroots(graph)

'The model is dynamically stable.

''**********************************************************************
''M1.A & M1.B: Identifying the number of cointegrating vectors
'***********************************************************************

'Having identified the appropriate number of lags to put in, I now go on to test for the appropriate number of cointegrating equations.

freeze(table_6_6_var6_coint3) table_6_6_var6.coint(s,3)

'This command estimates all possible combinations of constants and trends in the level data series and the cointegrating equations. Trace statistic of Case 3 indicate 1 cointegrating vector.
'
'GENERAL NOTE:, in practice, cases 1 and 5 are rarely used. One should use case 1 only if one knows that all series have zero mean. Case 5 may provide a good fit in-sample but will produce implausible forecasts out-of-sample. As a rough guide, use case 2 if none of the series appear to have a trend. For trending series, use case 3 if you believe all trends are stochastic; if you believe some of the series are trend stationary, use case 4.

'Note that the 5 cases are identified under "Johansen cointegration test" in EViews. They run from most restrictive (no constants in either the level series or CEs) to most general (trend terms in both the level series and CEs).

''******************************************************************
''M2.A, M2.B & M3: Vector Error Correction Model (VECM)
'*******************************************************************

' For estimating the LR relationship, corresponding VEC command is:

var table_6_6_vec3c.ec(c,1) 1 3 rer_def_nt a_tilde

'CONCLUSION:  I conclude that rer_def_nt and a_tilde are not cointegrated in the Philippines data.


